
----------------------------------------- DATA -----------------------------------------
use CrimeFile
set dateformat dmy

--
-- Table 'AccountT'
--
--sp_help tblaccount
INSERT tblAccount VALUES ('Admin', 'Control all function; Manage all info just as INSERT,UPDATE,DELETE; Manage User',GETDATE())
INSERT tblAccount VALUES ('User', 'Input and View the info; Generate Report',GETDATE())

--
-- Table 'User'
--
INSERT tblUser VALUES ('tiep',1,'tiep','12312312312','0984210296','tiep@gmail.com',0,GETDATE())
INSERT tblUser VALUES ('thien',2,'thien','78979879879','0984210232','thien@gmail.com',0,GETDATE())
INSERT tblUser VALUES ('duy',2,'duy','5465464545','0984210233','duy@gmail.com',0,GETDATE())
select * from tbluser u,tblaccount a
where u.idacc = a.idacc and USERname = 'tiep' and password = 'tiep'
--
-- Table 'ComplaintType'
--

INSERT [dbo].[tblComplaintType] ([IDCpT], [ComplaintT], [Descr]) VALUES (1, 'Economic Problem', '')
INSERT [dbo].[tblComplaintType] ([IDCpT], [ComplaintT], [Descr]) VALUES (2, 'Social Problem', 'Social Issue')
INSERT [dbo].[tblComplaintType] ([IDCpT], [ComplaintT], [Descr]) VALUES (3, 'Social Issue', 'Social Issue')
INSERT [dbo].[tblComplaintType] ([IDCpT], [ComplaintT], [Descr]) VALUES (4, 'Environmental Problem', 'Social Issue')


--
-- Table 'CriminalType'
--

INSERT [dbo].[tblCriminalType] ([IDCT], [CriType], [Descr]) VALUES (1, 'Wanted', 'Escaped from Prison or Not Captured ')
INSERT [dbo].[tblCriminalType] ([IDCT], [CriType], [Descr]) VALUES (2, 'TempCapture', 'Temporary captured to investigate more')
INSERT [dbo].[tblCriminalType] ([IDCT], [CriType], [Descr]) VALUES (3, 'Captured', 'Put in jails/ live in prison')
INSERT [dbo].[tblCriminalType] ([IDCT], [CriType], [Descr]) VALUES (4, 'Released', 'Finish Prison Times')
